Kelly P.
Kelly P.
Reactions
-
Re: Edit reports on a dashboard
@Marc Shecter One workaround that I have used in the past is to use the Web Content widget on the dashboard in conjunction with the embed code option in the publish settings of the sheet (edit by any…4 · -
Re: If or Index or Match....not sure what to use
@JSpears You'd want to use an index/match formula. Try this: =INDEX({SourceSheet_DocuSignStatus}, MATCH([Go-Live Checklist by Area]@row, {SourceSheet_Area}, 0)) Hope this helps!1 · -
Re: Need help on Formula
@Parvez Khan You could use something like this: =IFERROR(IF(OR(MONTH(Date@row) = 1, MONTH(Date@row) = 2, MONTH(Date@row) = 3), "Q1" + " " + YEAR(Date@row), IF(OR(MONTH(Date@row) =…1 · -
Re: Month to Number
@Angela L The basic idea of the formula that Itai provided is the one to use. However, since the month is just a text string, you don't need the month function (which works on dates, not text). Try t…2 · -
Re: IF formulas
@Ingrid A Try this: =IF([Targeted Competency]@row = [Actual Competency]@row, "Sideways", IF([Targeted Competency]@row = "Expert", IF([Actual Competency]@row <> [Targeted Com…1 ·
